class UpDateDataForDataBase:
    def get_like_name_table(like_name):
        sql = f"""SELECT table_name 
                  FROM information_schema.tables
                  WHERE table_schema="customer_quotation"
                  AND (table_name LIKE "obj_{like_name}%" 
                       OR table_name LIKE "empt{like_name}%");"""
        return sql

# 获取财务报价数据库中所有的表名
def get_all_table():
    sql = """SELECT table_name FROM information_schema.tables WHERE table_schema="customer_quotation";"""
    return sql

def get_nw_all_table():
    sql = """SELECT table_name FROM information_schema.tables WHERE table_schema="customer_quotation_nw";"""
    return sql


